﻿CREATE PROCEDURE dbo.AddMailSortSetting
	@TNTDepot NVARCHAR(50),
	@TNTMailingHouse NVARCHAR(50),
	@TNTClientCode NVARCHAR(50),
	@TNTJobReference NVARCHAR(50),
	@NexdoxMailsortService NVARCHAR(50),
	@LargeLetter BIT,
	@FixedWeight_NoOuter INT
AS
BEGIN

INSERT INTO MailsortSetting (TNTDepot, TNTMailingHouse, TNTClientCode, TNTJobReference, nexdoxMailsortService, largeletter, FixedWeight_NoOuter)
VALUES  (@TNTDepot,@TNTMailingHouse, @TNTClientCode, @TNTJobReference, @NexdoxMailsortService, @LargeLetter, @FixedWeight_NoOuter)

SELECT MailSortSettingID, TNTDepot, TNTMailingHouse, TNTClientCode, TNTJobReference, nexdoxMailsortService, largeletter, FixedWeight_NoOuter
FROM MailSortSetting WHERE MailSortSettingID = SCOPE_IDENTITY()

END